package com.example.jpademo.ref.generate.enums;

/**
 * @author guoxh
 * @Date 2020-08-31 01:05:38
 */
public enum CommonIdIncrSQL {

    BILL_BASE_ID("select ifnull(max(id),0)+1 into @id4 from bill_base"),
    BILLENTITY_BASE_ID("select ifnull(max(id),0)+1 into @id9 from billentity_base"),
    BILLTEMPLATE_BASE_ID("select ifnull(max(id),0)+1 into @id14 from billtemplate_base"),
    BILTPL_BASE_ID("select ifnull(max(id),0)+1 into @id19 from billtplgroup_base"),
    BILLITEM_BASE_ID("select ifnull(max(id),0)+1 into @id24 from billitem_base"),
    PUB_REF_ID("select ifnull(max(id),0)+1 into @id26 from pub_ref"),
    REFINNER_ITEM_ID("set @id25=@id24+1"),
    AUTH_MAIN_ID("select ifnull(max(id),0)+1 from auth_manager_refer"),
    AUTH_SUB_ID("select ifnull(max(id),0)+1 from auth_manager_refer_item");

    private final String sql;

    CommonIdIncrSQL(String sql){
        this.sql = sql;
    }

    public String getSql(){
        return this.sql;
    }
}
